clear all
set emptycells drop
set matsize 11000
set maxvar 32670

if c(username)=="jonathancolmer" { 
	cd "/Users/jonathancolmer/The Lab Dropbox/Jonathan Colmer/ShotSpotter_env/Journal_submissions/ReStat/Replication Folder" 
}

if c(username)=="jmc4qg" { 
	cd "/Users/jmc4qg/The Lab Dropbox/Jonathan Colmer/ShotSpotter_env/Journal_submissions/ReStat/Replication Folder" 
}

import delimited "Raw Data/county lat lon/us_county_latlng.csv", encoding(ISO-8859-1)clear

rename fips_code fips
rename lng lon
keep fips lat lon

replace fips = "51515" if fips == "51019"

save "Raw Data/county lat lon/us_county_latlng.dta", replace
